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
Get step-by-step solutions from verified subject matter experts
