Question: Hello below I have written out my code for SAS programming. I just want to know how I could attach my first and last name

Hello below I have written out my code for SAS programming. I just want to know how I could attach my first and last name as well as the date and time to the my code (preferably using macro variable, but if not that's fine too). I do not know if my copy and paste from editor in SAS will show up correctly in the code below, but if you know how to attach the aforementioned things into the code please provide the best explanation that you can!!! Thank you very much in advance!

procimportout=snowdatadatafile="G:\SnowStationsData.xlsx"dbms=Excelreplace;run;proccontentsdata=snowdata;run;procsql;selectcount(*)fromsnowdata;quit;procsql;selectcount(distinctSTATION_NAME)fromsnowdata;quit;procsql;selectSTATION_NAME,count(year)aslengthfromsnowdatagroupbySTATION_NAME;quit;procsql;selectyear,count(STATION_NAME)ASstationsfromsnowdatagroupbyyearorderbyyear;quit;procsql;selectstation_name,max(Max__SWE__inches__)asmax_SWEfromsnowdatagroupbystation_name;quit;procsql;createtablesnowdata1asupdatesnowdatasetStation_Name='ADINMOUNTAIN'wherestation_name='ADINMOUTAIN';2quit;procsql;selectcount(distinctregion)fromsnowdata;selectregion,count(distinctstation_name)asstationsfromsnowdatagroupbyregion;quit;procsql;createtablesnowstationsasselectdistinctstation_id,station_name,max(Max__SWE__inches__)asmax_swe,region,ELEVATION_IN_FEET_,latitude,longitudefromsnowdatawhereYEAR_RECORD_BEGAN<=1963andyear>=1963groupbystation_nameorderbystation_name;select*fromsnowstations;selectcount(*)fromsnowstations;quit;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!