I am a doctoral student and I have been using STATA for the last few years. I was accepted into a special restricted data workshop and had just a weekend to learn SAS. I tried a few different tutorials, including the one in the SAS program. NOTHING worked...until I found your channel. YOU ARE AMAZING. Thank you for helping me get thru a crash course in SAS! I was able to do the data analysis AND keep up with the class even though I had never used SAS until three days before it began. (I also watched your 2 hour tutorial...great job!) Thank you so much! 😃
Hi Mari, yes value creates a format on how the variable looks in the output and invalue is an informat on how you need to read in the variable if it is unstructured. Dates need an invalue to read them in and a format to make it readable in the output.
Thanks for watching I recommend googling your questions and visiting the sas documentation site: documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p1upn25lbfo6mkn1wncu4dyh9q91.htm
Mam I have a task for you If i have a space between the observations in the unaligned data, Example :- Data start ; Input id name$ age ; Cards; 101 Jhon abraham 34 102 Mathew wade 38 103 Jhon cena 42 104 Ellen 45 Run; Proc print data = start ; Run ; Which type of input method or format you use ?
You can change your input statement to be Input ID firstname $ lastname $ age; since you have first and last name you need to specify that in the input statements (for those who do not have a last name it should still work) Hope that helps
I am a doctoral student and I have been using STATA for the last few years. I was accepted into a special restricted data workshop and had just a weekend to learn SAS. I tried a few different tutorials, including the one in the SAS program. NOTHING worked...until I found your channel. YOU ARE AMAZING. Thank you for helping me get thru a crash course in SAS! I was able to do the data analysis AND keep up with the class even though I had never used SAS until three days before it began. (I also watched your 2 hour tutorial...great job!)
Thank you so much! 😃
Omg thanks so much for the kind words. So so glad I could help you with the class!
Jelly, you did a great job!
Thank you
Thank you so much Jelly!! As always great explanation!! :)
Thank you for viewing! :)
Great video! So this is sort of like creating LOOKUP TABLES in a database or DIMENSIONS in a data warehouse?
Thank you. You can think of it as lookup tables great observation
very good tutorial👌
Thank you soo much
Dear Jelly, could you please also explain difference between Value and InValue ?
Hi Mari, yes value creates a format on how the variable looks in the output and invalue is an informat on how you need to read in the variable if it is unstructured. Dates need an invalue to read them in and a format to make it readable in the output.
If you want to export using proc expor, is still keep the format ?
Yes if you export the output the format should carry over.
How do I create a permanent format library in sas?
Thanks for watching I recommend googling your questions and visiting the sas documentation site: documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p1upn25lbfo6mkn1wncu4dyh9q91.htm
Do you need a $ with the put statement? I have seen that this is not always necessary...
The $ just signifies its a character variable. No you don't have to have it just good practice.
Mam
I have a task for you
If i have a space between the observations in the unaligned data,
Example :-
Data start ;
Input id name$ age ;
Cards;
101 Jhon abraham 34
102 Mathew wade 38
103 Jhon cena 42
104 Ellen 45
Run;
Proc print data = start ;
Run ;
Which type of input method or format you use ?
You can change your input statement to be
Input ID firstname $ lastname $ age;
since you have first and last name you need to specify that in the input statements (for those who do not have a last name it should still work)
Hope that helps
@@learningwithjelly Thank you Mam , i got it